import pymysql
import pandas as pd
'''
pandas直接读取mysql
'''
# 打开数据库连接
conn = pymysql.connect(host="localhost",
                       port=3306,
                       user="root",
                       passwd="123123",
                       db="springdatajdbc")
sql = "select * from testdata"
data = pd.read_sql_query(sql, conn)
# 关闭连接
conn.close()
# print(data)

dataB = pd.read_excel(r'../data1/新-实时更新新型冠状病毒肺炎数据.xlsx')

remark_data = pd.read_excel(r'../data1/评论.xlsx')